4D Analytics

Math Toolbar

Max

  • Example: Max[{P123}]
  • Expects a single point
  • Returns the maximum value of the supplied point for the configured statistical conditions (for example, Use Last 1 Months).

Min

  • Example: Min[{P123}]
  • Expects a single point
  • Returns the minimum value of the supplied point for the configured statistical conditions (for example, Use Last 1 Months).

Absolute

  • Example: Abs[{P123}]
  • Expects a single point
  • Returns the absolute value of the supplied point (for example, Returns 3 where value = -3)

Sum (Sigma)

  • Example: Sum[{P123}]
  • Expects a single point
  • Returns the Sum of value for the supplied point for the configured statistical conditions (for example, Use Last 1 Months).

Natural Log

  • Example: Ln[{P123}]
  • Expects a single point
  • Returns the natural log of the value of the supplied point.

Log to base 10

  • Example: LogTen[{P123}]
  • Expects a single point
  • Returns the common log of the value of the supplied point.

Square

  • Example: SQR[{P123}]
  • Expects a single point
  • Returns the square of the value of the supplied point.

Square Root

  • Example: SqRt[{P123}]
  • Expects a single point
  • Returns the square root of the value of the supplied point.

X to the power n

  • Example: {P123}^n
  • Expects a single point
  • Raises the value of the supplied point to the specified power (for example, {P123}^3 would return the cube of the value)

gSum

  • Example: gSum[{P123},{P124},{P125}]
  • Expects a list of points, comma separated.
  • Returns the sum of values for all points over configured statistical conditions (for example, Use Last 1 Months).

gMin, gMax, gAvg

  • Example: gMin[{P123},{P124},{P125}]
  • Expects a list of points, comma separated.
  • All behave similarly to gSum, returning appropriate values over configured statistical conditions (for example, Use Last 1 Months).

“Pi” and “e”

“Pi” and “e” are constants.